USE Liberty
GO

---------------------------------------------------------------------------------------------------
--	TypesOfActivity Population Script
---------------------------------------------------------------------------------------------------

SET NOCOUNT ON 

IF EXISTS(SELECT 1 FROM dbo.TypesOfActivity)
BEGIN
	PRINT 'TypesOfActivity already populated; no action taken'
END
ELSE
BEGIN

	INSERT INTO dbo.TypesOfActivity (Description)
	VALUES('Creation')
	INSERT INTO dbo.TypesOfActivity (Description)
	VALUES('Edit')
	INSERT INTO dbo.TypesOfActivity (Description)
	VALUES('Approval')
	INSERT INTO dbo.TypesOfActivity (Description)
	VALUES('Dispersal')
	INSERT INTO dbo.TypesOfActivity (Description)
	VALUES('Follow-up')

	PRINT 'TypesOfMilitaryBranch has been populated'
END

SELECT * FROM dbo.TypesOfActivity

